<?php 
global $dir_tpl, $tb_fix, $temp, $anyDB;  
$shopurl = get_data('shop_url','config_values');
$temp->assign("shopurl",$shopurl);
$temp->assign( 'base_tpl', "".$dir_tpl."" );
$sql = "select t.*,tm.tme_title
            from ".$tb_fix."_tour as t
                left join ".$tb_fix."_tour_menu as tm
                    on t.tou_category = tm.tme_id
            where t.tou_home_act = 1 and t.tou_root_cat_id = 2
            order by tou_id desc
            limit 0,15";
            //echo $sql;
$q = $anyDB->query($sql);
$t = $anyDB->numRows($q);
if($t > 0){
    $r = $anyDB->getAll($q);
    foreach($r as $k =>$v){
        $r[$k]['tme_title']=convertText($v['tme_title']);
        $r[$k]['tou_url_name'] = convertText($v['tou_title']);
        //$r[$k]['tou_titlecut'] = subCutString($v['tou_title'],3);
    }
    $temp->assign("rows",$r);    
}
$temp->display("$dir_tpl/blocks/slide_home/index.mct"); 
?> 
